<!DOCTYPE html>
<html lang="en-US">
    <head>
        <title>Win32::ODBC - ODBC Extension for Win32 - metacpan.org</title>
        <link rel="preload" as="fetch" href="https://metacpan.org/account/login_status" crossorigin="anonymous" />
        <link href="https://metacpan.org/_assets/b8ccceeed47a0652049703d99326a9cea4933443.css" rel="stylesheet" type="text/css">
        <script src="https://metacpan.org/_assets/6bfedafe2d7caa915b7d84f61b45936818e3242e.js" type="text/javascript" defer></script>
        <link rel="alternate" type="application/rss+xml" title="Recent CPAN Uploads of Win32-ODBC - MetaCPAN" href="https://metacpan.org/dist/Win32-ODBC/releases.rss" />
        <link rel="canonical" href="./Win32::ODBC.html" />
        <meta name="description" content="ODBC Extension for Win32" />
        <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=5">
        <link rel="shortcut icon" href="https://metacpan.org/static/icons/favicon.ico">
        <link rel="apple-touch-icon" sizes="152x152" href="https://metacpan.org/static/icons/apple-touch-icon.png">
        <link rel="search" href="https://metacpan.org/static/opensearch.xml" type="application/opensearchdescription+xml" title="MetaCPAN">
        <script>
          (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
          (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
          m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
          })(window,document,'script','//www.google-analytics.com/analytics.js','ga');

          (function(skey, ga_id){
            ga('create', ga_id, {
              siteSpeedSampleRate : 100,
              storage             : 'none',
              clientId            : localStorage.getItem(skey)
            });
            ga(function(tracker) {
              localStorage.setItem(skey, tracker.get('clientId'));
            });
            ga('send', 'pageview');
          })('ga:clientId', 'UA-27829474-1');
        </script>
<meta name="twitter:card"        content="summary" />
<meta name="twitter:url"         content="https://metacpan.org/pod/Win32::ODBC" />
<meta name="twitter:title"       content="Win32::ODBC" />
<meta name="twitter:description" content="ODBC Extension for Win32" />
<meta name="twitter:site"        content="metacpan" />
    </head>
    <body>
        <nav class="navbar navbar-default" role="navigation">
            <div class="header-logo-large hidden-xs">
              <a href="https://metacpan.org/" tabindex="0">
                <svg class="logo" aria-label="MetaCPAN">
                  <use class="logo" href="/static/images/metacpan-logo.svg#logo" />
                </svg>
              </a>
            </div>
            <div class="header-logo-icon visible-xs">
              <a href="https://metacpan.org/">
                <svg class="logo" aria-label="MetaCPAN">
                  <use class="logo" href="/static/images/metacpan-logo.svg#dots" />
                </svg>
              </a>
            </div>
            <ul class="nav navbar-nav menu-items hidden-xs hidden-sm">
              <li><a href="https://metacpan.org/about">About</a></li>
              <li><a href="https://metacpan.org/about/sponsors">Sponsor</a></li>
              <li><a href="https://grep.metacpan.org/">grep::cpan</a></li>
              <li><a href="https://metacpan.org/recent">Recent</a></li>
              <li><a href="https://metacpan.org/about/faq">FAQ</a></li>
              <li><a href="https://metacpan.org/tools">Tools</a></li>
              <li><a href="https://fastapi.metacpan.org/">API</a></li>
            </ul>
            <ul class="nav navbar-nav navbar-right">
                <button type="button" class="searchbar-btn visible-xs visible-sm">
                    <i class="fa fa-search button-fa-icon"></i>
                </button>
                <form action="https://metacpan.org/search" class="searchbar-form visible-md visible-lg search-form form-horizontal">
                   <input type="hidden" name="size" id="metacpan_search-size" value="20">
                  <div class="form-group">
                      <div class="search-group">
                        <i class="fa fa-search"></i>
                        <input type="text" name="q" placeholder="Search the CPAN" size="41" autocorrect="off" autocapitalize="off" spellcheck="false" id="metacpan_search-input" class="form-control" value="">
                      </div>
                  </div>
                </form>
                    <li class="icon-slidepanel visible-xs visible-sm">
                      <button data-toggle="slidepanel" data-target=".slidepanel">
                        <span class="button-fa-icon">
                          <i class="fa fa-bars slidepanel-open"></i>
                          <i class="fa fa-times slidepanel-close"></i>
                        </span>
                      </button>
                    </li>
                <form action="https://metacpan.org/account/logout" method="POST" id="metacpan-logout"></form>
                <li class="dropdown logged_in" style="display: none;">
                    <button type="button" class="dropdown-toggle" data-toggle="dropdown">
                      <i class="fa fa-user button-fa-icon logged-in-icon" aria-hidden="true"></i>
                      <i class="fas fa-chevron-down"></i>
                    </button>
                    <ul class="dropdown-menu">
                        <li><a href="https://metacpan.org/account/identities">Identities</a></li>
                        <li><a href="https://metacpan.org/account/profile">Profile</a></li>
                        <li><a href="https://metacpan.org/account/favorite/list">Favorites</a></li>
                        <li>
                            <a href="./Win32::ODBC.html#" type="button" onclick="$('#metacpan-logout').submit(); return false">
                              Logout
                            </a>
                        </li>
                    </ul>
                </li>
                <li class="dropdown logged_out" style="display: none;">
                    <button type="button" class="dropdown-toggle" data-toggle="dropdown">
                      <i class="fa fa-user button-fa-icon" aria-hidden="true"></i>
                      <i class="fas fa-chevron-down"></i>
                    </button>
                    <ul class="dropdown-menu">
                        <li>
                            <a href="https://metacpan.org/login/github">
                                <i class="fab fa-github fa-fw"></i>
                                GitHub
                            </a>
                        </li>
                        <li>
                            <a href="https://metacpan.org/login/twitter">
                                <i class="fab fa-twitter fa-fw"></i>
                                Twitter
                            </a>
                        </li>
                        <li>
                            <a href="https://metacpan.org/login/google">
                                <i class="fab fa-google fa-fw"></i>
                                Google
                            </a>
                        </li>
                    </ul>
                </li>
                <li class="dropdown logged_placeholder">
                    <button>
                      <i class="fa fa-user button-fa-icon" aria-hidden="true"></i>
                    </button>
                </li>
            </ul>
        </nav>
        <div class="page-content ">
          <!--
          <div class="top-notify-banner">
            <i class="fas fa-info-circle"></i>
          </div>
          -->
          <nav class="sidebar">
            <div class="slidepanel">
              <ul class="nav-list ">
    <li class="nav-header no-margin-top">
      <div class="ttip" data-toggle="tooltip" data-placement="bottom" title="The date that this version of Win32-ODBC was released.">
      <span class="relatize">01 Sep 2020 03:34:17 UTC</span>
    </li>
  <li>
    Distribution: <a href="https://metacpan.org/dist/Win32-ODBC">Win32-ODBC</a>
  </li>
  <li>
    Module version: 0.036
  </li>
  <li>
    <a data-keyboard-shortcut="g s" href="https://metacpan.org/dist/Win32-ODBC/source/ODBC.pm">Source</a>
    (<a href="https://metacpan.org/dist/Win32-ODBC/source/ODBC.pm?raw=1">raw</a>)
  </li>
  <li>
    <a data-keyboard-shortcut="g b" href="https://metacpan.org/dist/Win32-ODBC/source">Browse</a>
    (<a href="https://metacpan.org/dist/Win32-ODBC/source?raw=1">raw</a>)
  </li>
    <li>
      <a data-keyboard-shortcut="g c" href="https://metacpan.org/dist/Win32-ODBC/changes">Changes</a>
    </li>
    <li>
      <a class="nopopup" href="https://metacpan.org/dist/Win32-ODBC/contribute">How to Contribute</a>
    </li>
    <li>
        <a rel="noopener nofollow" data-keyboard-shortcut="g r" href="https://github.com/jandubois/win32-odbc">Repository</a>
    </li>
    <li>
      <a rel="noopener nofollow" data-keyboard-shortcut="g i" href="https://rt.cpan.org/Public/Dist/Display.html?Name=Win32-ODBC">Issues</a>
      (3)
    </li>
    <li>
      <a rel="noopener nofollow" href="http://matrix.cpantesters.org/?dist=Win32-ODBC+0.036" title="Matrix">Testers</a>
        <span title="(pass / fail / na)">(<a rel="noopener nofollow" href="https://www.cpantesters.org/distro/W/Win32-ODBC.html?oncpan=1&amp;distmat=1&amp;version=0.036&amp;grade=2" style="color: #090">1</a> / <a rel="noopener nofollow" href="https://www.cpantesters.org/distro/W/Win32-ODBC.html?oncpan=1&amp;distmat=1&amp;version=0.036&amp;grade=3" style="color: #900">0</a> / <a rel="noopener nofollow" href="https://www.cpantesters.org/distro/W/Win32-ODBC.html?oncpan=1&amp;distmat=1&amp;version=0.036&amp;grade=4">7</a>)</span>
    </li>
    <li>
      <a rel="noopener nofollow" href="http://cpants.cpanauthors.org/release/JDB/Win32-ODBC-0.036">Kwalitee</a>
    </li>
    <li>
      <div class="ttip" data-toggle="tooltip" data-placement="bottom" title="The # people with an indexing permission on Win32-ODBC who have released something to CPAN in the last 2 years (i.e. the # people likely able to release critical fixes in a timely manner)">
      Bus factor: 1
      </div>
    </li>
    <li>
      <a rel="noopener nofollow" href="http://cpancover.com/latest/Win32-ODBC-0.036/index.html">% Coverage </a>
    </li>
    <li>
      License: perl_5
    </li>
    <li>
      Perl: v5.6.0
    </li>
    <li class="nav-header">Activity</li>
    <li>
<div class="activity-graph">
    <img src="https://metacpan.org/dist/Win32-ODBC/activity.svg?res=month" />
    <div class="comment">24 month</div>
</div>
    </li>
    <li class="nav-header">Tools</li>
    <li>
      <a itemprop="downloadUrl" href="https://cpan.metacpan.org/authors/id/J/JD/JDB/Win32-ODBC-0.036.tar.gz">
      Download (<span itemprop="fileSize">90.18KB</span>)</a>
    </li>
    <li>
      <a href="https://explorer.metacpan.org/?url=%2Fmodule%2FJDB%2FWin32-ODBC-0.036%2FODBC.pm">
        MetaCPAN Explorer
      </a>
    </li>
    <li>
      <a href="https://metacpan.org/dist/Win32-ODBC/permissions">
        Permissions
      </a>
    </li>
    <li>
      <a href="https://metacpan.org/dist/Win32-ODBC/releases.rss">
        Subscribe to distribution
      </a>
    </li>
    <li>
      <button class="btn btn-link" data-toggle="modal" data-target="#metacpan_install-instructions-dialog">
        Install Instructions
      </button>
    </li>
    <li>
      <form action="https://metacpan.org/search">
        <input type="hidden" name="q" value="dist:Win32-ODBC">
        <input type="search" name="q" placeholder="Search distribution" class="form-control tool-bar-form">
        <input type="submit" style="display: none">
      </form>
    </li>
    <li>
      <form action="https://grep.metacpan.org/search">
        <input type="hidden" name="qd" value="Win32-ODBC">
        <input type="hidden" name="source" value="metacpan">
        <input type="search" name="q" placeholder="grep distribution" class="form-control tool-bar-form">
        <input type="submit" style="display: none">
     </form>
    </li>
    <li class="version-jump">
<select onchange="document.location.href=&#39;/release/&#39;+this.value+&#39;/view/ODBC.pm&#39;" class="form-control tool-bar-form">
  <option disabled selected>Jump to version</option>
<option
  disabled
  value="JDB/Win32-ODBC-0.036"
>0.036
  (JDB on 2020-09-01)</option>
<optgroup label="BackPAN">'
<option
  
  value="JDB/Win32-ODBC-0.035"
>0.035
  (JDB on 2013-12-06)</option>
<option
  
  value="XLAT/Win32-ODBC-0.035-withoutworldwriteables"
>0.035
  (XLAT on 2011-04-11)</option>
<option
  
  value="XLAT/Win32-ODBC-0.035"
>0.035
  (XLAT on 2011-04-11)</option>
<option
  
  value="JDB/Win32-ODBC-0.034"
>0.034
  (JDB on 2008-06-14)</option>
<option
  
  value="JDB/Win32-ODBC-0.033"
>0.033
  (JDB on 2008-04-18)</option>
</optgroup>
</select>
    </li>
    <li class="version-diff">
<select onchange="document.location.href='/release/JDB/Win32-ODBC-0.036/diff/' + encodeURIComponent(this.value) + '/ODBC.pm'
" class="form-control tool-bar-form">
  <option disabled selected>Diff with version</option>
<option
  disabled
  value="JDB/Win32-ODBC-0.036"
>0.036
  (JDB on 2020-09-01)</option>
<optgroup label="BackPAN">'
<option
  
  value="JDB/Win32-ODBC-0.035"
>0.035
  (JDB on 2013-12-06)</option>
<option
  
  value="XLAT/Win32-ODBC-0.035-withoutworldwriteables"
>0.035
  (XLAT on 2011-04-11)</option>
<option
  
  value="XLAT/Win32-ODBC-0.035"
>0.035
  (XLAT on 2011-04-11)</option>
<option
  
  value="JDB/Win32-ODBC-0.034"
>0.034
  (JDB on 2008-06-14)</option>
<option
  
  value="JDB/Win32-ODBC-0.033"
>0.033
  (JDB on 2008-04-18)</option>
</optgroup>
</select>
    </li>

    <li>
<ul class="dependencies">
  <li class="nav-header">Dependencies</li>
  <li><i class="ttip" title="dynamic_config enabled">unknown</i></li>
  <li>
    <hr>
  </li>
  <li>
    <a href="https://metacpan.org/module/Win32::ODBC/requires">Reverse dependencies</a>
  </li>
  <li>
    <a href="http://deps.cpantesters.org/?module=Win32%3A%3AODBC">CPAN Testers List</a>
  </li>
  <li>
    <a href="https://cpandeps.grinnz.com/?dist=Win32-ODBC">Dependency graph</a>
  </li>
</ul>
    </li>
    <li class="nav-header">Permalinks</li>
    <li>
      <a href="https://metacpan.org/release/JDB/Win32-ODBC-0.036/view/ODBC.pm">This version</a>
    </li>
    <li>
      <a href="./Win32::ODBC.html">Latest version</a>
    </li>
    <li>
<div class="plussers">
<div class="nav-header">++ed by:</div>
<div>
<a class="display-all" href="https://metacpan.org/author/XLAT"><img src="https://www.gravatar.com/avatar/a477fe9cd31dd7f08e1962deff6ef5c5?d=identicon&amp;s=20" title="XLAT" alt="XLAT"></a>
</div>
<!-- Display counts of plussers-->
<div>
    <a href="https://metacpan.org/dist/Win32-ODBC/plussers">1 PAUSE user</a>
</div>
</div>
    </li>
    <li>
<div id="metacpan_contributors">
  <div>
    <button class="btn-link"
      onclick="$(this).hide(); $('#metacpan_contributors ul').slideDown(); return false;"
    >and 2 contributors</button>
  </div>
  <ul style="display: none">
    <li class="contributor"
      data-cpan-author="DAVEROTH"
      data-contrib-email="rothd@roth.net"
    >
      <a href="https://metacpan.org/author/DAVEROTH" class="cpan-author">
      <img class="gravatar" width="20" height="20" src="https://www.gravatar.com/avatar/030be013f483b9e28de77366b3c211df?d=identicon&amp;s=20" />
      Dave Roth
      </a>
    </li>
    <li class="contributor"
      data-contrib-email="jand@activestate.com"
    >
      <img class="gravatar" width="20" height="20" src="https://www.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?d=identicon&amp;s=20" />
      Jan Dubois
    </li>
  </ul>
</div>
    </li>
              </ul>
            </div>
          </nav>
          <div class="content-navigation">
<div class="breadcrumbs">
  <span>
    <a data-keyboard-shortcut="g a" rel="author" href="https://metacpan.org/author/JDB" class="author-name">Jan Dubois</a>
  </span>
  <span>&nbsp;/&nbsp;</span>
  <div class="release dist-release status-latest maturity-released">
    <span class="dropdown"><b class="caret"></b></span>
<select onchange="document.location.href=&#39;/release/&#39;+this.value+&#39;/view/ODBC.pm&#39;" class="">
<option
  selected
  value="JDB/Win32-ODBC-0.036"
>0.036
  (JDB on 2020-09-01)</option>
<optgroup label="BackPAN">'
<option
  
  value="JDB/Win32-ODBC-0.035"
>0.035
  (JDB on 2013-12-06)</option>
<option
  
  value="XLAT/Win32-ODBC-0.035-withoutworldwriteables"
>0.035
  (XLAT on 2011-04-11)</option>
<option
  
  value="XLAT/Win32-ODBC-0.035"
>0.035
  (XLAT on 2011-04-11)</option>
<option
  
  value="JDB/Win32-ODBC-0.034"
>0.034
  (JDB on 2008-06-14)</option>
<option
  
  value="JDB/Win32-ODBC-0.033"
>0.033
  (JDB on 2008-04-18)</option>
</optgroup>
</select>
    <a data-keyboard-shortcut="g d" class="release-name" href="https://metacpan.org/dist/Win32-ODBC">Win32-ODBC-0.036</a>
  </div>
<span class="river-gauge-gauge">
  <svg width="24px"
       height="15px"
       version="1.1"
       xmlns="http://www.w3.org/2000/svg"
       xmlns:xlink="http://www.w3.org/1999/xlink">

    <g>
      <title>        River stage zero &#10;
          No dependents
      </title>

      <rect x="0"  y="0" width="4" height="15" fill="#e4e2e2" />
      <rect x="5"  y="0" width="4" height="15" fill="#e4e2e2" />
      <rect x="10"  y="0" width="4" height="15" fill="#e4e2e2" />
      <rect x="15"  y="0" width="4" height="15" fill="#e4e2e2" />
      <rect x="20"  y="0" width="4" height="15" fill="#e4e2e2" />
    </g>
  </svg>

</span>
<div id="Win32-ODBC-fav" class="logged_in">
<form action="https://metacpan.org/account/favorite/add" style="display: inline" onsubmit="return favDistribution(this)">
    <input type="hidden" name="remove" value="0">
    <input type="hidden" name="release" value="Win32-ODBC-0.036">
    <input type="hidden" name="author" value="JDB">
    <input type="hidden" name="distribution" value="Win32-ODBC">
    <button type="submit" class="favorite highlight"><span>1</span> ++</button>
</form>
</div>
<div class="logged_out">
<a href="./Win32::ODBC.html" onclick="alert('Please sign in to add favorites'); return false" class="favorite highlight">
<span>1</span> ++</a>
</div>
   / <span>Win32::ODBC</span>
</div>
          </div>
          <main class="content">


<nav class="toc">
  <div class="toc-header"><strong>Contents</strong></div>
<ul>
  <li><a href="./Win32::ODBC.html#NAME">NAME</a></li>
  <li><a href="./Win32::ODBC.html#SYNOPSIS">SYNOPSIS</a></li>
  <li><a href="./Win32::ODBC.html#DESCRIPTION">DESCRIPTION</a>
    <ul>
      <li><a href="./Win32::ODBC.html#Background">Background</a></li>
      <li><a href="./Win32::ODBC.html#Benefits">Benefits</a></li>
    </ul>
  </li>
  <li><a href="./Win32::ODBC.html#CONSTANTS">CONSTANTS</a></li>
  <li><a href="./Win32::ODBC.html#SPECIAL-NOTATION">SPECIAL NOTATION</a></li>
  <li><a href="./Win32::ODBC.html#CONSTRUCTOR">CONSTRUCTOR</a></li>
  <li><a href="./Win32::ODBC.html#METHODS">METHODS</a></li>
  <li><a href="./Win32::ODBC.html#LIMITATIONS">LIMITATIONS</a></li>
  <li><a href="./Win32::ODBC.html#INSTALLATION-NOTES">INSTALLATION NOTES</a></li>
  <li><a href="./Win32::ODBC.html#OTHER-DOCUMENTATION">OTHER DOCUMENTATION</a></li>
  <li><a href="./Win32::ODBC.html#AUTHOR">AUTHOR</a></li>
  <li><a href="./Win32::ODBC.html#CREDITS">CREDITS</a></li>
  <li><a href="./Win32::ODBC.html#DISCLAIMER">DISCLAIMER</a></li>
  <li><a href="./Win32::ODBC.html#HISTORY">HISTORY</a></li>
  <li><a href="./Win32::ODBC.html#COPYRIGHT">COPYRIGHT</a></li>
</ul></nav>
<div class="pod anchors">
<h1 id="NAME">NAME</h1>

<p>Win32::ODBC - ODBC Extension for Win32</p>

<h1 id="SYNOPSIS">SYNOPSIS</h1>

<p>To use this module, include the following statement at the top of your script:</p>

<pre><code>    use Win32::ODBC;</code></pre>

<p>Next, create a data connection to your DSN:</p>

<pre><code>    $Data = new Win32::ODBC(&quot;MyDSN&quot;);</code></pre>

<p><b>NOTE</b>: <i>MyDSN</i> can be either the <i>DSN</i> as defined in the ODBC Administrator, <i>or</i> it can be an honest-to-God <i>DSN Connect String</i>.</p>

<pre><code>    Example: &quot;DSN=My Database;UID=Brown Cow;PWD=Moo;&quot;</code></pre>

<p>You should check to see if <code>$Data</code> is indeed defined, otherwise there has been an error.</p>

<p>You can now send SQL queries and retrieve info to your heart&#39;s content! See the description of the methods provided by this module below and also the file <i>TEST.PL</i> as referred to in <a href="./Win32::ODBC.html#INSTALLATION-NOTES">&quot;INSTALLATION NOTES&quot;</a> to see how it all works.</p>

<p>Finally, <b>MAKE SURE</b> that you close your connection when you are finished:</p>

<pre><code>    $Data-&gt;Close();</code></pre>

<h1 id="DESCRIPTION">DESCRIPTION</h1>

<h2 id="Background">Background</h2>

<p>This is a hack of Dan DeMaggio&#39;s &lt;dmag@umich.edu&gt; <i>NTXS.C</i> ODBC implementation. I have recoded and restructured most of it including most of the <i>ODBC.PM</i> package, but its very core is still based on Dan&#39;s code (thanks Dan!).</p>

<p>The history of this extension is found in the file <i>HISTORY.TXT</i> that comes with the original archive (see <a href="./Win32::ODBC.html#INSTALLATION-NOTES">&quot;INSTALLATION NOTES&quot;</a> below).</p>

<h2 id="Benefits">Benefits</h2>

<p>And what are the benefits of this module?</p>

<ul>

<li><p>The number of ODBC connections is limited by memory and ODBC itself (have as many as you want!).</p>

</li>
<li><p>The working limit for the size of a field is 10,240 bytes, but you can increase that limit (if needed) to a max of 2,147,483,647 bytes. (You can always recompile to increase the max limit.)</p>

</li>
<li><p>You can open a connection by either specifying a DSN or a connection string!</p>

</li>
<li><p>You can open and close the connections in any order!</p>

</li>
<li><p>Other things that I can not think of right now... :)</p>

</li>
</ul>

<h1 id="CONSTANTS">CONSTANTS</h1>

<p>This package defines a number of constants. You may refer to each of these constants using the notation <code>ODBC::xxxxx</code>, where <code>xxxxx</code> is the constant.</p>

<p>Example:</p>

<pre><code>   print ODBC::SQL_SQL_COLUMN_NAME, &quot;\n&quot;;</code></pre>

<h1 id="SPECIAL-NOTATION"><a id="SPECIAL"></a>SPECIAL NOTATION</h1>

<p>For the method documentation that follows, an <b>*</b> following the method parameters indicates that that method is new or has been modified for this version.</p>

<h1 id="CONSTRUCTOR">CONSTRUCTOR</h1>

<dl>

<dt id="new-(-ODBC_OBJECT-|-DSN-[,-(OPTION1,-VALUE1),-(OPTION2,-VALUE2)-...]-)-*"><a id="new"></a><a id="new---ODBC_OBJECT---DSN----OPTION1--VALUE1---OPTION2--VALUE2"></a>new ( ODBC_OBJECT | DSN [, (OPTION1, VALUE1), (OPTION2, VALUE2) ...] ) *</dt>
<dd>

<p>Creates a new ODBC connection based on <code>DSN</code>, or, if you specify an already existing ODBC object, then a new ODBC object will be created but using the ODBC Connection specified by <code>ODBC_OBJECT</code>. (The new object will be a new <i>hstmt</i> using the <i>hdbc</i> connection in <code>ODBC_OBJECT</code>.)</p>

<p><code>DSN</code> is <i>Data Source Name</i> or a proper <code>ODBCDriverConnect</code> string.</p>

<p>You can specify SQL Connect Options that are implemented before the actual connection to the DSN takes place. These option/values are the same as specified in <code>GetConnectOption</code>/<code>SetConnectOption</code> (see below) and are defined in the ODBC API specs.</p>

<p>Returns a handle to the database on success, or <i>undef</i> on failure.</p>

</dd>
</dl>

<h1 id="METHODS">METHODS</h1>

<dl>

<dt id="Catalog-(-QUALIFIER,-OWNER,-NAME,-TYPE-)"><a id="Catalog"></a><a id="Catalog---QUALIFIER--OWNER--NAME--TYPE"></a>Catalog ( QUALIFIER, OWNER, NAME, TYPE )</dt>
<dd>

<p>Tells ODBC to create a data set that contains table information about the DSN. Use <code>Fetch</code> and <code>Data</code> or <code>DataHash</code> to retrieve the data. The returned format is:</p>

<pre><code>    [Qualifier] [Owner] [Name] [Type]</code></pre>

<p>Returns <i>true</i> on error.</p>

</dd>
<dt id="ColAttributes-(-ATTRIBUTE-[,-FIELD_NAMES-]-)"><a id="ColAttributes"></a><a id="ColAttributes---ATTRIBUTE---FIELD_NAMES"></a>ColAttributes ( ATTRIBUTE [, FIELD_NAMES ] )</dt>
<dd>

<p>Returns the attribute <code>ATTRIBUTE</code> on each of the fields in the list <code>FIELD_NAMES</code> in the current record set. If <code>FIELD_NAMES</code> is empty, then all fields are assumed. The attributes are returned as an associative array.</p>

</dd>
<dt id="ConfigDSN-(-OPTION,-DRIVER,-ATTRIBUTE1-[,-ATTRIBUTE2,-ATTRIBUTE3,-...-]-)"><a id="ConfigDSN"></a><a id="ConfigDSN---OPTION--DRIVER--ATTRIBUTE1---ATTRIBUTE2--ATTRIBUTE3"></a>ConfigDSN ( OPTION, DRIVER, ATTRIBUTE1 [, ATTRIBUTE2, ATTRIBUTE3, ... ] )</dt>
<dd>

<p>Configures a DSN. <code>OPTION</code> takes on one of the following values:</p>

<pre><code>    ODBC_ADD_DSN.......Adds a new DSN.
    ODBC_MODIFY_DSN....Modifies an existing DSN.
    ODBC_REMOVE_DSN....Removes an existing DSN.

    ODBC_ADD_SYS_DSN.......Adds a new System DSN.
    ODBC_MODIFY_SYS_DSN....Modifies an existing System DSN.
    ODBC_REMOVE_SYS_DSN....Removes an existing System DSN.</code></pre>

<p>You must specify the driver <code>DRIVER</code> (which can be retrieved by using <code>DataSources</code> or <code>Drivers</code>).</p>

<p><code>ATTRIBUTE1</code> <b>should</b> be <i>&quot;DSN=xxx&quot;</i> where <i>xxx</i> is the name of the DSN. Other attributes can be any DSN attribute such as:</p>

<pre><code>    &quot;UID=Cow&quot;
    &quot;PWD=Moo&quot;
    &quot;Description=My little bitty Data Source Name&quot;</code></pre>

<p>Returns <i>true</i> on success, <i>false</i> on failure.</p>

<p><b>NOTE 1</b>: If you use <code>ODBC_ADD_DSN</code>, then you must include at least <i>&quot;DSN=xxx&quot;</i> and the location of the database.</p>

<p>Example: For MS Access databases, you must specify the <i>DatabaseQualifier</i>:</p>

<pre><code>    &quot;DBQ=c:\\...\\MyDatabase.mdb&quot;</code></pre>

<p><b>NOTE 2</b>: If you use <code>ODBC_MODIFY_DSN</code>, then you need only specify the <i>&quot;DNS=xxx&quot;</i> attribute. Any other attribute you include will be changed to what you specify.</p>

<p><b>NOTE 3</b>: If you use <code>ODBC_REMOVE_DSN</code>, then you need only specify the <i>&quot;DSN=xxx&quot;</i> attribute.</p>

</dd>
<dt id="Connection-()"><a id="Connection"></a>Connection ()</dt>
<dd>

<p>Returns the connection number associated with the ODBC connection.</p>

</dd>
<dt id="Close-()"><a id="Close"></a>Close ()</dt>
<dd>

<p>Closes the ODBC connection. No return value.</p>

</dd>
<dt id="Data-(-[-FIELD_NAME-]-)"><a id="Data"></a><a id="Data-----FIELD_NAME"></a>Data ( [ FIELD_NAME ] )</dt>
<dd>

<p>Returns the contents of column name <code>FIELD_NAME</code> or the current row (if nothing is specified).</p>

</dd>
<dt id="DataHash-(-[-FIELD1,-FIELD2,-...-]-)"><a id="DataHash"></a><a id="DataHash-----FIELD1--FIELD2"></a>DataHash ( [ FIELD1, FIELD2, ... ] )</dt>
<dd>

<p>Returns the contents for <code>FIELD1, FIELD2, ...</code> or the entire row (if nothing is specified) as an associative array consisting of:</p>

<pre><code>    {Field Name} =&gt; Field Data</code></pre>

</dd>
<dt id="DataSources-()"><a id="DataSources"></a>DataSources ()</dt>
<dd>

<p>Returns an associative array of Data Sources and ODBC remarks about them. They are returned in the form of:</p>

<pre><code>    $ArrayName{&#39;DSN&#39;}=Driver</code></pre>

<p>where <i>DSN</i> is the Data Source Name and ODBC Driver used.</p>

</dd>
<dt id="Debug-(-[-1-|-0-]-)"><a id="Debug"></a><a id="Debug-----1---0"></a>Debug ( [ 1 | 0 ] )</dt>
<dd>

<p>Sets the debug option to on or off. If nothing is specified, then nothing is changed.</p>

<p>Returns the debugging value (<i>1</i> or <i>0</i>).</p>

</dd>
<dt id="Drivers-()"><a id="Drivers"></a>Drivers ()</dt>
<dd>

<p>Returns an associative array of ODBC Drivers and their attributes. They are returned in the form of:</p>

<pre><code>    $ArrayName{&#39;DRIVER&#39;}=Attrib1;Attrib2;Attrib3;...</code></pre>

<p>where <i>DRIVER</i> is the ODBC Driver Name and <i>AttribX</i> are the driver-defined attributes.</p>

</dd>
<dt id="DropCursor-(-[-CLOSE_TYPE-]-)"><a id="DropCursor"></a><a id="DropCursor-----CLOSE_TYPE"></a>DropCursor ( [ CLOSE_TYPE ] )</dt>
<dd>

<p>Drops the cursor associated with the ODBC object. This forces the cursor to be deallocated. This overrides <code>SetStmtCloseType</code>, but the ODBC object does not lose the <code>StmtCloseType</code> setting. <code>CLOSE_TYPE</code> can be any valid <code>SmtpCloseType</code> and will perform a close on the stmt using the specified close type.</p>

<p>Returns <i>true</i> on success, <i>false</i> on failure.</p>

</dd>
<dt id="DumpData-()"><a id="DumpData"></a>DumpData ()</dt>
<dd>

<p>Dumps to the screen the fieldnames and all records of the current data set. Used primarily for debugging. No return value.</p>

</dd>
<dt id="Error-()"><a id="Error"></a>Error ()</dt>
<dd>

<p>Returns the last encountered error. The returned value is context dependent:</p>

<p>If called in a <i>scalar</i> context, then a <i>3-element array</i> is returned:</p>

<pre><code>    ( ERROR_NUMBER, ERROR_TEXT, CONNECTION_NUMBER )</code></pre>

<p>If called in a <i>string</i> context, then a <i>string</i> is returned:</p>

<pre><code>    &quot;[ERROR_NUMBER] [CONNECTION_NUMBER] [ERROR_TEXT]&quot;</code></pre>

<p>If debugging is on then two more variables are returned:</p>

<pre><code>    ( ..., FUNCTION, LEVEL )</code></pre>

<p>where <code>FUNCTION</code> is the name of the function in which the error occurred, and <code>LEVEL</code> represents extra information about the error (usually the location of the error).</p>

</dd>
<dt id="FetchRow-(-[-ROW-[,-TYPE-]-]-)"><a id="FetchRow"></a><a id="FetchRow-----ROW---TYPE"></a>FetchRow ( [ ROW [, TYPE ] ] )</dt>
<dd>

<p>Retrieves the next record from the keyset. When <code>ROW</code> and/or <code>TYPE</code> are specified, the call is made using <code>SQLExtendedFetch</code> instead of <code>SQLFetch</code>.</p>

<p><b>NOTE 1</b>: If you are unaware of <code>SQLExtendedFetch</code> and its implications, stay with just regular <code>FetchRow</code> with no parameters.</p>

<p><b>NOTE 2</b>: The ODBC API explicitly warns against mixing calls to <code>SQLFetch</code> and <code>SQLExtendedFetch</code>; use one or the other but not both.</p>

<p>If <i>ROW</i> is specified, it moves the keyset <b>RELATIVE</b> <code>ROW</code> number of rows.</p>

<p>If <i>ROW</i> is specified and <code>TYPE</code> is <b>not</b>, then the type used is <b>RELATIVE</b>.</p>

<p>Returns <i>true</i> when another record is available to read, and <i>false</i> when there are no more records.</p>

</dd>
<dt id="FieldNames-()"><a id="FieldNames"></a>FieldNames ()</dt>
<dd>

<p>Returns an array of fieldnames found in the current data set. There is no guarantee on order.</p>

</dd>
<dt id="GetConnections-()"><a id="GetConnections"></a>GetConnections ()</dt>
<dd>

<p>Returns an array of connection numbers showing what connections are currently open.</p>

</dd>
<dt id="GetConnectOption-(-OPTION-)"><a id="GetConnectOption"></a><a id="GetConnectOption---OPTION"></a>GetConnectOption ( OPTION )</dt>
<dd>

<p>Returns the value of the specified connect option <code>OPTION</code>. Refer to ODBC documentation for more information on the options and values.</p>

<p>Returns a string or scalar depending upon the option specified.</p>

</dd>
<dt id="GetCursorName-()"><a id="GetCursorName"></a>GetCursorName ()</dt>
<dd>

<p>Returns the name of the current cursor as a string or <i>undef</i>.</p>

</dd>
<dt id="GetData-()"><a id="GetData"></a>GetData ()</dt>
<dd>

<p>Retrieves the current row from the dataset. This is not generally used by users; it is used internally.</p>

<p>Returns an array of field data where the first element is either <i>false</i> (if successful) and <i>true</i> (if <b>not</b> successful).</p>

</dd>
<dt id="getDSN-(-[-DSN-]-)"><a id="getDSN"></a><a id="getDSN-----DSN"></a>getDSN ( [ DSN ] )</dt>
<dd>

<p>Returns an associative array indicating the configuration for the specified DSN.</p>

<p>If no DSN is specified then the current connection is used.</p>

<p>The returned associative array consists of:</p>

<pre><code>    keys=DSN keyword; values=Keyword value. $Data{$Keyword}=Value</code></pre>

</dd>
<dt id="GetFunctions-(-[-FUNCTION1,-FUNCTION2,-...-]-)"><a id="GetFunctions"></a><a id="GetFunctions-----FUNCTION1--FUNCTION2"></a>GetFunctions ( [ FUNCTION1, FUNCTION2, ... ] )</dt>
<dd>

<p>Returns an associative array indicating the ability of the ODBC Driver to support the specified functions. If no functions are specified, then a 100 element associative array is returned containing all possible functions and their values.</p>

<p><code>FUNCTION</code> must be in the form of an ODBC API constant like <code>SQL_API_SQLTRANSACT</code>.</p>

<p>The returned array will contain the results like:</p>

<pre><code>    $Results{SQL_API_SQLTRANSACT}=Value</code></pre>

<p>Example:</p>

<pre><code>    $Results = $O-&gt;GetFunctions(
                                $O-&gt;SQL_API_SQLTRANSACT,
                                SQL_API_SQLSETCONNECTOPTION
                               );
    $ConnectOption = $Results{SQL_API_SQLSETCONNECTOPTION};
    $Transact = $Results{SQL_API_SQLTRANSACT};</code></pre>

</dd>
<dt id="GetInfo-(-OPTION-)"><a id="GetInfo"></a><a id="GetInfo---OPTION"></a>GetInfo ( OPTION )</dt>
<dd>

<p>Returns a string indicating the value of the particular option specified.</p>

</dd>
<dt id="GetMaxBufSize-()"><a id="GetMaxBufSize"></a>GetMaxBufSize ()</dt>
<dd>

<p>Returns the current allocated limit for <i>MaxBufSize</i>. For more info, see <code>SetMaxBufSize</code>.</p>

</dd>
<dt id="GetSQLState-()-*"><a id="GetSQLState"></a>GetSQLState () *</dt>
<dd>

<p>Returns a string indicating the SQL state as reported by ODBC. The SQL state is a code that the ODBC Manager or ODBC Driver returns after the execution of a SQL function. This is helpful for debugging purposes.</p>

</dd>
<dt id="GetStmtCloseType-(-[-CONNECTION-]-)"><a id="GetStmtCloseType"></a><a id="GetStmtCloseType-----CONNECTION"></a>GetStmtCloseType ( [ CONNECTION ] )</dt>
<dd>

<p>Returns a string indicating the type of closure that will be used every time the <i>hstmt</i> is freed. See <code>SetStmtCloseType</code> for details.</p>

<p>By default, the connection of the current object will be used. If <code>CONNECTION</code> is a valid connection number, then it will be used.</p>

</dd>
<dt id="GetStmtOption-(-OPTION-)"><a id="GetStmtOption"></a><a id="GetStmtOption---OPTION"></a>GetStmtOption ( OPTION )</dt>
<dd>

<p>Returns the value of the specified statement option <code>OPTION</code>. Refer to ODBC documentation for more information on the options and values.</p>

<p>Returns a string or scalar depending upon the option specified.</p>

</dd>
<dt id="MoreResults-()"><a id="MoreResults"></a>MoreResults ()</dt>
<dd>

<p>This will report whether there is data yet to be retrieved from the query. This can happen if the query was a multiple select.</p>

<p>Example:</p>

<pre><code>    &quot;SELECT * FROM [foo] SELECT * FROM [bar]&quot;</code></pre>

<p><b>NOTE</b>: Not all drivers support this.</p>

<p>Returns <i>1</i> if there is more data, <i>undef</i> otherwise.</p>

</dd>
<dt id="RowCount-(-CONNECTION-)"><a id="RowCount"></a><a id="RowCount---CONNECTION"></a>RowCount ( CONNECTION )</dt>
<dd>

<p>For <i>UPDATE</i>, <i>INSERT</i> and <i>DELETE</i> statements, the returned value is the number of rows affected by the request or <i>-1</i> if the number of affected rows is not available.</p>

<p><b>NOTE 1</b>: This function is not supported by all ODBC drivers! Some drivers do support this but not for all statements (e.g., it is supported for <i>UPDATE</i>, <i>INSERT</i> and <i>DELETE</i> commands but not for the <i>SELECT</i> command).</p>

<p><b>NOTE 2</b>: Many data sources cannot return the number of rows in a result set before fetching them; for maximum interoperability, applications should not rely on this behavior.</p>

<p>Returns the number of affected rows, or <i>-1</i> if not supported by the driver in the current context.</p>

</dd>
<dt id="Run-(-SQL-)"><a id="Run"></a><a id="Run---SQL"></a>Run ( SQL )</dt>
<dd>

<p>Executes the SQL command <b>SQL</b> and dumps to the screen info about it. Used primarily for debugging.</p>

<p>No return value.</p>

</dd>
<dt id="SetConnectOption-(-OPTION-)-*"><a id="SetConnectOption"></a><a id="SetConnectOption---OPTION"></a>SetConnectOption ( OPTION ) *</dt>
<dd>

<p>Sets the value of the specified connect option <b>OPTION</b>. Refer to ODBC documentation for more information on the options and values.</p>

<p>Returns <i>true</i> on success, <i>false</i> otherwise.</p>

</dd>
<dt id="SetCursorName-(-NAME-)-*"><a id="SetCursorName"></a><a id="SetCursorName---NAME"></a>SetCursorName ( NAME ) *</dt>
<dd>

<p>Sets the name of the current cursor.</p>

<p>Returns <i>true</i> on success, <i>false</i> otherwise.</p>

</dd>
<dt id="SetPos-(-ROW-[,-OPTION,-LOCK-]-)-*"><a id="SetPos"></a><a id="SetPos---ROW---OPTION--LOCK"></a>SetPos ( ROW [, OPTION, LOCK ] ) *</dt>
<dd>

<p>Moves the cursor to the row <code>ROW</code> within the current keyset (<b>not</b> the current data/result set).</p>

<p>Returns <i>true</i> on success, <i>false</i> otherwise.</p>

</dd>
<dt id="SetMaxBufSize-(-SIZE-)"><a id="SetMaxBufSize"></a><a id="SetMaxBufSize---SIZE"></a>SetMaxBufSize ( SIZE )</dt>
<dd>

<p>This sets the <i>MaxBufSize</i> for a particular connection. This will most likely never be needed but...</p>

<p>The amount of memory that is allocated to retrieve the field data of a record is dynamic and changes when it need to be larger. I found that a memo field in an MS Access database ended up requesting 4 Gig of space. This was a bit much so there is an imposed limit (2,147,483,647 bytes) that can be allocated for data retrieval.</p>

<p>Since it is possible that someone has a database with field data greater than 10,240, you can use this function to increase the limit up to a ceiling of 2,147,483,647 (recompile if you need more).</p>

<p>Returns the max number of bytes.</p>

</dd>
<dt id="SetStmtCloseType-(-TYPE-[,-CONNECTION-]-)"><a id="SetStmtCloseType"></a><a id="SetStmtCloseType---TYPE---CONNECTION"></a>SetStmtCloseType ( TYPE [, CONNECTION ] )</dt>
<dd>

<p>Sets a particular <i>hstmt</i> close type for the connection. This is the same as <code>ODBCFreeStmt(hstmt, TYPE)</code>. By default, the connection of the current object will be used. If <code>CONNECTION</code> is a valid connection number, then it will be used.</p>

<p><code>TYPE</code> may be one of:</p>

<pre><code>    SQL_CLOSE
    SQL_DROP
    SQL_UNBIND
    SQL_RESET_PARAMS</code></pre>

<p>Returns a string indicating the newly set type.</p>

</dd>
<dt id="SetStmtOption-(-OPTION-)-*"><a id="SetStmtOption"></a><a id="SetStmtOption---OPTION"></a>SetStmtOption ( OPTION ) *</dt>
<dd>

<p>Sets the value of the specified statement option <code>OPTION</code>. Refer to ODBC documentation for more information on the options and values.</p>

<p>Returns <i>true</i> on success, <i>false</i> otherwise.</p>

</dd>
<dt id="ShutDown-()"><a id="ShutDown"></a>ShutDown ()</dt>
<dd>

<p>Closes the ODBC connection and dumps to the screen info about it. Used primarily for debugging.</p>

<p>No return value.</p>

</dd>
<dt id="Sql-(-SQL_STRING-)"><a id="Sql"></a><a id="Sql---SQL_STRING"></a>Sql ( SQL_STRING )</dt>
<dd>

<p>Executes the SQL command <code>SQL_STRING</code> on the current connection.</p>

<p>Returns <i>?</i> on success, or an error number on failure.</p>

</dd>
<dt id="TableList-(-QUALIFIER,-OWNER,-NAME,-TYPE-)"><a id="TableList"></a><a id="TableList---QUALIFIER--OWNER--NAME--TYPE"></a>TableList ( QUALIFIER, OWNER, NAME, TYPE )</dt>
<dd>

<p>Returns the catalog of tables that are available in the DSN. For an unknown parameter, just specify the empty string <i>&quot;&quot;</i>.</p>

<p>Returns an array of table names.</p>

</dd>
<dt id="Transact-(-TYPE-)-*"><a id="Transact"></a><a id="Transact---TYPE"></a>Transact ( TYPE ) *</dt>
<dd>

<p>Forces the ODBC connection to perform a <i>rollback</i> or <i>commit</i> transaction.</p>

<p><code>TYPE</code> may be one of:</p>

<pre><code>    SQL_COMMIT
    SQL_ROLLBACK</code></pre>

<p><b>NOTE</b>: This only works with ODBC drivers that support transactions. Your driver supports it if <i>true</i> is returned from:</p>

<pre><code>    $O-&gt;GetFunctions($O-&gt;SQL_API_SQLTRANSACT)[1]</code></pre>

<p>(See <code>GetFunctions</code> for more details.)</p>

<p>Returns <i>true</i> on success, <i>false</i> otherwise.</p>

</dd>
<dt id="Version-(-PACKAGES-)"><a id="Version"></a><a id="Version---PACKAGES"></a>Version ( PACKAGES )</dt>
<dd>

<p>Returns an array of version numbers for the requested packages (<i>ODBC.pm</i> or <i>ODBC.PLL</i>). If the list <code>PACKAGES</code> is empty, then all version numbers are returned.</p>

</dd>
</dl>

<h1 id="LIMITATIONS">LIMITATIONS</h1>

<p>What known problems does this thing have?</p>

<ul>

<li><p>If the account under which the process runs does not have write permission on the default directory (for the process, not the ODBC DSN), you will probably get a runtime error during a <code>SQLConnection</code>. I don&#39;t think that this is a problem with the code, but more like a problem with ODBC. This happens because some ODBC drivers need to write a temporary file. I noticed this using the MS Jet Engine (Access Driver).</p>

</li>
<li><p>This module has been neither optimized for speed nor optimized for memory consumption.</p>

</li>
</ul>

<h1 id="INSTALLATION-NOTES"><a id="INSTALLATION"></a>INSTALLATION NOTES</h1>

<p>If you wish to use this module with a build of Perl other than ActivePerl, you may wish to fetch the original source distribution for this module at:</p>

<pre><code>  ftp://ftp.roth.net:/pub/ntperl/ODBC/970208/Bin/Win32_ODBC_Build_CORE.zip</code></pre>

<p>or one of the other archives at that same location. See the included README for hints on installing this module manually, what to do if you get a <i>parse exception</i>, and a pointer to a test script for this module.</p>

<h1 id="OTHER-DOCUMENTATION"><a id="OTHER"></a>OTHER DOCUMENTATION</h1>

<p>Find a FAQ for Win32::ODBC at:</p>

<pre><code>  http://www.roth.net/odbc/odbcfaq.htm</code></pre>

<h1 id="AUTHOR">AUTHOR</h1>

<p>Dave Roth &lt;rothd@roth.net&gt;</p>

<h1 id="CREDITS">CREDITS</h1>

<p>Based on original code by Dan DeMaggio &lt;dmag@umich.edu&gt;</p>

<h1 id="DISCLAIMER">DISCLAIMER</h1>

<p>I do not guarantee <b>ANYTHING</b> with this package. If you use it you are doing so <b>AT YOUR OWN RISK</b>! I may or may not support this depending on my time schedule.</p>

<h1 id="HISTORY">HISTORY</h1>

<p>Last Modified 1999.09.25.</p>

<h1 id="COPYRIGHT">COPYRIGHT</h1>

<p>Copyright (c) 1996-1998 Dave Roth. All rights reserved.</p>

<p>Courtesy of Roth Consulting: http://www.roth.net/consult/</p>

<p>Use under GNU General Public License. Details can be found at: http://www.gnu.org/copyleft/gpl.html</p></div>

<div id="metacpan_install-instructions-dialog" class="modal fade">
  <div class="modal-dialog">
    <div class="modal-content">
      <div class="modal-header">
        <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
        <h4 class="modal-title">Module Install Instructions</h4>
      </div>
      <div class="modal-body">
        <p>To install Win32::ODBC, copy and paste the appropriate command in to your terminal.</p>
        <p><a href="https://metacpan.org/dist/App-cpanminus/view/bin/cpanm">cpanm</a></p>
        <pre><code>cpanm Win32::ODBC</code></pre>
        <p><a href="https://metacpan.org/pod/CPAN">CPAN shell</a></p>
        <pre><code>perl -MCPAN -e shell
install Win32::ODBC</code></pre>
        <p>For more information on module installation, please visit <a href="https://www.cpan.org/modules/INSTALL.html">the detailed CPAN module installation guide</a>.</p>
      </div>
      <div class="modal-footer">
        <a href="./Win32::ODBC.html#" data-dismiss="modal" class="btn">Close</a>
      </div>
    </div>
  </div>
</div>
          </main>
          <div class="content-pagination">
          </div>
        </div>
        <footer class="footer">
          <div class="footer-container">
            <div class="footer-social">
              <div class="footer-link footer-logo">
                <a href="https://metacpan.org/">
                  <img src="https://metacpan.org/static/images/metacpan-logo.svg" alt="MetaCPAN" />
                </a>
              </div>
              <a class="footer-social-link" href="https://github.com/metacpan">
                <i class="fab fa-github-square"></i>
              </a>
              <a class="footer-social-link" href="https://fosstodon.org/@metacpan">
                <i class="fab fa-mastodon"></i>
              </a>
            </div>
            <div class="footer-links">
              <div class="footer-link">
                  <a href="https://metacpan.org/about">About</a>
              </div>
              <div class="footer-link">
                  <a href="https://metacpan.org/about/sponsors">Sponsor</a>
              </div>
              <div class="footer-link">
                  <a href="https://grep.metacpan.org">grep::cpan</a>
              </div>
              <div class="footer-link">
                  <a href="https://metacpan.org/recent">Recent</a>
              </div>
              <div class="footer-link">
                  <a href="https://metacpan.org/about/faq">FAQ</a>
              </div>
              <div class="footer-link">
                  <a href="https://metacpan.org/tools">Tools</a>
              </div>
              <div class="footer-link">
                  <a href="https://fastapi.metacpan.org/">API</a>
              </div>
              <div class="footer-link">
                  <a href="https://www.perl.org/">Perl.org</a>
              </div>
            </div>
            <div class="footer-sponsors">
              <a class="footer-sponsor-link" target="_blank" href="https://www.bytemark.co.uk/" rel="noopener">
                <img class="footer-sponsor-bytemark" src="https://metacpan.org/static/images/sponsors/bytemark_logo.svg" alt="Bytemark logo">
              </a>
              <a class="footer-sponsor-link" target="_blank" href="https://www.liquidweb.com/" rel="noopener">
                <img class="footer-sponsor-liquidweb" src="https://metacpan.org/static/images/sponsors/liquidweb_logo.png" alt="liquidweb logo">
              </a>
              <a class="footer-sponsor-link" target="_blank" href="https://deriv.com/careers/" rel="noopener">
                <img class="footer-sponsor-deriv" src="https://metacpan.org/static/images/sponsors/deriv.svg" alt="Deriv logo">
              </a>
              <a class="footer-sponsor-link" target="_blank" href="https://geocode.xyz" rel="noopener">
                <img class="footer-sponsor-geocode" src="https://metacpan.org/static/images/sponsors/geocodelogo.svg" alt="Geocode logo">
              </a>
              <a class="footer-sponsor-link" target="_blank" href="https://www.fastly.com/" rel="noopener">
                <img class="footer-sponsor-fastly" src="https://metacpan.org/static/images/sponsors/fastly_logo.svg" alt="Fastly logo">
              </a>
              <a class="footer-sponsor-link" target="_blank" href="https://opencagedata.com" rel="noopener">
                <img class="footer-sponsor-opencage" src="https://metacpan.org/static/images/sponsors/open-cage.svg" alt="OpenCage logo">
              </a>
            </div>
          </div>
        </footer>
        <div class="modal fade" tabindex="-1" role="dialog" id="metacpan_keyboard-shortcuts">
          <div class="modal-dialog">
            <div class="modal-content">
              <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal">&times;</button>
                <h4 class="modal-title">Keyboard Shortcuts</h4>
              </div>
              <div class="modal-body row">
<div class="col-md-6">
  <table class="table keyboard-shortcuts">
    <thead>
      <tr>
        <th></th>
        <th>Global</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td class="keys">
          <kbd>s</kbd>
        </td>
        <td>Focus search bar</td>
      </tr>
      <tr>
        <td class="keys">
          <kbd>?</kbd>
        </td>
        <td>Bring up this help dialog</td>
      </tr>
    </tbody>
  </table>

  <table class="table keyboard-shortcuts">
    <thead>
      <tr>
        <th></th>
        <th>GitHub</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td class="keys">
          <kbd>g</kbd> <kbd>p</kbd>
        </td>
        <td>Go to pull requests</td>
      </tr>
      <tr>
        <td class="keys">
          <kbd>g</kbd> <kbd>i</kbd>
        </td>
        <td>go to github issues (only if github is preferred repository)</td>
      </tr>
    </tbody>
  </table>
</div>

<div class="col-md-6">
  <table class="table keyboard-shortcuts">
    <thead>
      <tr>
        <th></th>
        <th>POD</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td class="keys">
          <kbd>g</kbd> <kbd>a</kbd>
        </td>
        <td>Go to author</td>
      </tr>
      <tr>
        <td class="keys">
          <kbd>g</kbd> <kbd>c</kbd>
        </td>
        <td>Go to changes</td>
      </tr>
      <tr>
        <td class="keys">
          <kbd>g</kbd> <kbd>i</kbd>
        </td>
        <td>Go to issues</td>
      </tr>
      <tr>
        <td class="keys">
          <kbd>g</kbd> <kbd>d</kbd>
        </td>
        <td>Go to dist</td>
      </tr>
      <tr>
        <td class="keys">
          <kbd>g</kbd> <kbd>r</kbd>
        </td>
        <td>Go to repository/SCM</td>
      </tr>
      <tr>
        <td class="keys">
          <kbd>g</kbd> <kbd>s</kbd>
        </td>
        <td>Go to source</td>
      </tr>
      <tr>
        <td class="keys">
          <kbd>g</kbd> <kbd>b</kbd>
        </td>
        <td>Go to file browse</td>
      </tr>

    </tbody>
  </table>
</div>

<div class="col-md-12">
  <table class="table keyboard-shortcuts">
    <thead>
      <tr>
        <th></th>
        <th>Search terms</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td><em>module:</em> (e.g. <a href="https://metacpan.org/search?q=module%3APlugin">module:Plugin</a>)</td>
      </tr>
      <tr>
        <td><em>distribution:</em> (e.g. <a href="https://metacpan.org/search?q=distribution%3ADancer+auth">distribution:Dancer auth</a>)</td>
      </tr>
      <tr>
        <td><em>author:</em> (e.g. <a href="https://metacpan.org/search?q=author%3ASONGMU+Redis">author:SONGMU Redis</a>)</td>
      </tr>
      <tr>
        <td><em>version:</em> (e.g. <a href="https://metacpan.org/search?q=version%3A1.00">version:1.00</a>)</td>
      </tr>
    </tbody>
  </table>
</div>
              </div>
              <div class="modal-footer"></div>
            </div>
          </div>
        </div>
    </body>
</html>
